Import VA TXT file to Excel

You can ask questions here about Trevor and Gerard's exciting new book on Luthiery.

Moderators: kiwigeo, Jeremy D

Post Reply
Craig Bumgarner
Blackwood
Posts: 195
Joined: Thu Apr 11, 2013 10:28 pm
Location: Drayden, MD, USA

Import VA TXT file to Excel

Post by Craig Bumgarner » Mon Oct 28, 2013 10:54 pm

Dumb question. How do you import VA text files to Excell? I can get the file to open in Excel and get each line of data in a separate row, but I get both the frequency and the amplitude in one column, so I can't plot them.
Craig Bumgarner

Bumgarner Guitar Blog

Jorge Bertholdo
Wandoo
Posts: 13
Joined: Thu Aug 22, 2013 9:41 am
Location: Porto - Portugal
Contact:

Re: Import VA TXT file to Excel

Post by Jorge Bertholdo » Tue Oct 29, 2013 12:36 am

Craig Bumgarner wrote:Dumb question. How do you import VA text files to Excell? I can get the file to open in Excel and get each line of data in a separate row, but I get both the frequency and the amplitude in one column, so I can't plot them.
I use open office, but I believe in Exel should be something similar.

1. Export from VA as Text.
2. In libreOffice Choose File - Open and click the file to import.
3. Select "Text CSV" from the File type combo box. Click Open.
4. The Text Import dialog appears. Check "separated by" and "space"
5. Click OK.

The numbers VA text will open in two columns. Now you can plot the data in a chart.
Guitar, Lut and Violin maker

http://www.jorgebertholdo.com

Craig Bumgarner
Blackwood
Posts: 195
Joined: Thu Apr 11, 2013 10:28 pm
Location: Drayden, MD, USA

Re: Import VA TXT file to Excel

Post by Craig Bumgarner » Tue Oct 29, 2013 1:08 am

Thanks, that works. It is a bit different in Excel 2007, but same idea: Go to the DATA tab, GET EXTERNAL DATA, TEXT, FROM TEXT, (select file to import), DELIMITED, by SPACE.
Craig Bumgarner

Bumgarner Guitar Blog

Craig Bumgarner
Blackwood
Posts: 195
Joined: Thu Apr 11, 2013 10:28 pm
Location: Drayden, MD, USA

Re: Import VA TXT file to Excel

Post by Craig Bumgarner » Tue Oct 29, 2013 4:59 am

For future reference. The chart type needs to be a SCATTER chart, not a LINE chart. Scatter chart allows values to be used for both the X and Y axis. Line allows values only on the Y axis, the X axis units are just the row number. Scatter charts can be format as points, connected points or "smooth line". A smooth line scatter chart (not to be confused with a LINE chart) will look similar to VA graphs. Multiple guitars can be thrown on one graph by right clicking on the plot and then clicking SELECT DATA -> ADD.
Craig Bumgarner

Bumgarner Guitar Blog

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests