• Home
  • About
  • Best Practices
  • Webinars
  • Resources

ShareASale Blog

  • Twitter
  • Facebook
  • Pinterest
  • Google+
  • LinkedIn
  • ShareASale
  • Merchants
  • Affiliates
  • Trending
  • New & Notable
  • Alert!
  • Around the Office

How to View a Pipe-Delimited Text File in Excel

February 13, 2016 by ShareASale Leave a Comment

Sometimes you  may find a file comes in a pipe-delimited text format instead of a traditional .CSV – but don’t worry, they are just as easy to deal with in Excel.

Follow these quick steps and you’ll see that importing a pipe delimited text file is very easy in Excel.

Step 1: This is where we start – copy and paste the file into Excel, you can do this by opening the file in Notepad and just copying the whole thing.

Step 2: Highlight column A – this is where all the data is.

Step 3: From the Data Menu – choose “Text to Columns”

Step 4: In the box that comes up, choose “Delimited”

Step 5: Indicate that you are going to then use the pipe symbol “|”

This is the pipe symbol on your keyboard.

Step 6: You’re basically done – just hit “Finish”

Filed Under: Trending

ShareASale

ShareASale

Leave A Comment Cancel reply

Interested in Hearing More from ShareASale?

To receive our latest news and email communications, please opt-in to our Blog Newsletter below.
* = required field
Tell us about you:



Events Calendar

«July 2020»
SunMonTuesWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 

Merchant Catalog

ShareASale 2014 Summer Catalog

Tags

#BestOf #BuildingBlocks #HowTo #LessonsLearned #Q4Prep #TheInterface affiliate affiliate resources affiliate summit affiliate timesavers affiliate tips around the office bfcm2016 black friday blogger tips blogging Brian Littleton client services conferences conference tips content tips cyber monday Featured fun friday general news gift guide gift guides gift guides 2016 interface merchant features merchant focus merchant programs merchant resources merchants merchant timesavers merchant tips month of the interface must have merchants new and notable new merchants product datafeeds q4 reports technology tip of the day

About Us

ShareASale has been in business for 16 years, exclusively as an Affiliate Marketing Network. Our technology receives accolades for speed, efficiency and accuracy - and our reputation as a fair and honest business is well known within the industry.

Navigation

  • Home
  • About
  • Best Practices
  • Webinars
  • Resources
  • Affiliates Posts
  • Merchants Posts
  • Trending
  • New & Notable
  • Around the Office

Contact Us

SHAREASALE@SHAREASALE.COM
(312) 321-0487

  • Twitter
  • Facebook
  • Pinterest
  • Google+
  • LinkedIn
  • ShareASale