|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
56 Users Online (54 Members):
Show Users Online
- Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM |
Forums
Forums >> Revit Building >> Technical Support >> Excel to comma delimited txt file
|
|
active
![jarosa Avatar](user_avatar/53278.jpg)
Joined: Mon, Feb 18, 2008
251 Posts
![4 Stars: 5 Votes](/images/stars_4.gif) |
I have an window catalog with all the Andersen Tilt Wash windows that i modified and now is saved as an .xls file. It appears Revit needs to read the file with comma delimited. How do I convert the xls file to comma delimited .txt file. I tried save as with the different .txt files to no avail. Revit would not open the catalog. John
|
This user is offline |
View Website
|
![](images/spacer.gif) |
|
active
Joined: Sat, Aug 30, 2008
1 Posts No Rating |
The txt file and your Revit file needs to have the same name, and be in the same folder
|
This user is offline |
|
![](images/spacer.gif) |
active
![jarosa Avatar](user_avatar/53278.jpg)
Joined: Mon, Feb 18, 2008
251 Posts
![4 Stars: 5 Votes](/images/stars_4.gif) |
Got that. But when i save as a .txt file, Revit won't open the catalog. It gives me an error: Row 1: unacceptable list separater y (with stupid double dots above), Acceptable list separaters are ,;:| What i need is a way to convert the .xls file to a file that revit will read as a catalog. I started typing in the new catalog in word pad and can get that to work, but it's easier to edit in excel. Unless I'm doing something wrong i can't save as from excel to a file type Revit will read.
|
This user is offline |
View Website
|
![](images/spacer.gif) |
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 391 Votes](/images/stars_3.5.gif) |
Did you try saving it from excel as a CSV file (don't keep any fexcel formatting) then renaming the extension to txt.... that looks right to me.
|
This user is offline |
|
![](images/spacer.gif) |
active
![jarosa Avatar](user_avatar/53278.jpg)
Joined: Mon, Feb 18, 2008
251 Posts
![4 Stars: 5 Votes](/images/stars_4.gif) |
WWHub, You the man. I did try the .csv file but i didn't think to reaname it to .txt (Not sure why, i renamed everything else) Anyways, worked like a charm. Andersen double hung full catalog for single wide units coming soon. Thanks, John
|
This user is offline |
View Website
|
![](images/spacer.gif) |
![](images/spacer.gif) |
Similar Threads |
Family Creation Look-up table interactivity |
Revit Systems >> Technical Support
|
Thu, Jul 24, 2014 at 7:38:37 AM
|
3
|
Changing of unit seperation symbol from comma to point |
Revit Building >> Technical Support
|
Mon, Jan 11, 2010 at 7:25:22 AM
|
3
|
Exporting schedules to Excel with multiple lines in a cell |
Revit Building >> Technical Support
|
Thu, Jan 24, 2013 at 9:55:29 AM
|
4
|
Exporting Schedules into excel format |
General Discussion >> Revit Project Management
|
Fri, Mar 13, 2015 at 5:53:44 AM
|
3
|
Custom Keynotes |
Community >> Newbies
|
Tue, Mar 5, 2013 at 8:36:19 AM
|
0
|
![](images/spacer.gif) |
|
Site Stats
Members: | 2016873 | Objects: | 22944 | Forum Posts: | 152211 | Job Listings: | 3 |
|