RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

174 Users Online (73 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

Search this ThreadSearch this Thread | Page 1 of 1 |

Sun, Mar 15, 2009 at 7:41:53 PM | Excel to comma delimited txt file

#1

jarosa


active
jarosa Avatar

Joined: Tue, Feb 19, 2008
251 Posts
4 Stars: 5 Votes


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

Sun, Mar 15, 2009 at 8:31:46 PM | Excel to comma delimited txt file

#2

verdier


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

 

Sun, Mar 15, 2009 at 9:00:16 PM | Excel to comma delimited txt file

#3

jarosa


active
jarosa Avatar

Joined: Tue, Feb 19, 2008
251 Posts
4 Stars: 5 Votes


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

Mon, Mar 16, 2009 at 12:51:18 PM | Excel to comma delimited txt file

#4

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 356 Votes


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

 

Mon, Mar 16, 2009 at 3:57:04 PM | Excel to comma delimited txt file

#5

jarosa


active
jarosa Avatar

Joined: Tue, Feb 19, 2008
251 Posts
4 Stars: 5 Votes


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

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Family Creation Look-up table interactivity

Revit Systems >> Technical Support

Thu, Jul 24, 2014 at 12:38:37 PM

3

Changing of unit seperation symbol from comma to point

Revit Building >> Technical Support

Mon, Jan 11, 2010 at 1:25:22 PM

3

Exporting schedules to Excel with multiple lines in a cell

Revit Building >> Technical Support

Thu, Jan 24, 2013 at 3:55:29 PM

4

Exporting Schedules into excel format

General Discussion >> Revit Project Management

Fri, Mar 13, 2015 at 10:53:44 AM

3

Custom Keynotes

Community >> Newbies

Tue, Mar 5, 2013 at 2:36:19 PM

0

Site Stats

Members:

1473718

Objects:

21054

Forum Posts:

151018

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 1.3390

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights