Getting Around Columbia Without Wasting Your Time
Columbia is compact enough that you can cover most of it in a day, but it is spread out enough that bad routing will cost you an hour you don't have. I spent three days last October mapping out a route between the state capitol, the Riverbanks Zoo area, and the main downtown corridor, and I learned quickly that GPS alone will lead you through some unglamorous side streets if you aren't paying attention. Here is what actually works when you are trying to see the real parts of the city rather than just the highway exits. Start at the South Carolina State House. It sits on a hill and the surrounding parkland is genuinely nice for walking. The grounds are free and you can do a full loop in about twenty minutes. There are restrooms near the visitor center, which opened at nine AM on weekdays. If you arrive after eleven, you will find most of the nearby coffee shops already slammed with lunch crowds. I learned this the hard way on a Tuesday. There is a small lot behind the capitol visitor center that is easy to miss because the entrance is from Gervais Street, not Broad Street. Taking the wrong approach led me circling the block twice before I found it.
From the capitol, head east on Main Street. This is your spine. It runs directly to the Columbia Museum of Art and intersects with Two Notch Road, which is where Riverbanks Zoo lives. Main Street has street parking but the meters are enforced between eight AM and six PM. A fifty dollar ticket is not worth the fifteen dollars you save. Use the public garages on Gervais or use the app-based payment system they rolled out a couple years back. It works reasonably well though I have seen it glitch on older Android phones. For food, skip the chain restaurants off I-26 and I-77. The real options cluster around Three Notch Road near the university and along Main Street downtown. Fig Tree Restaurant on Main gets mentioned a lot but honestly it is overpriced for what it is. Try King Street Market instead. It is a converted railway building with local vendors, live music on weekends, and parking that is actually free in the adjacent lot after six PM. I stood in line for twenty minutes once for their wood-fired pizza and it was worth every minute. Not worth it the second time because they ran out of the spicy honey I always order. They fixed that by putting a limit of two per customer during peak hours. The Congaree Riverwalk is worth the drive if you are into walking trails. It is about fifteen minutes north of downtown off I-26. The trail itself is flat and well-maintained. The problem is the parking lot fills up by ten AM on Saturdays. I have left twice because there was nowhere to park. There is a smaller overflow lot on Blakeney Road that most people do not know about. It is a dirt pull-off behind a hardware store and it has room for maybe six cars. I figured it out by asking a ranger on my first visit. He did not seem happy about giving away that information.
If you want a museum, the Columbia Museum of Art on Main Street is decent for a midsize city. The Egyptian collection is the strongest part. The building itself is fine but the HVAC system sounds like it is dying every time you walk past the modern art wing. No complaints about the exhibits themselves though. General admission is twelve dollars and free on Thursdays after four. You do not need a reservation unless you are hitting a special exhibit, which are rare. Hotel recommendations depend entirely on what you are here for. Downtown Marriott is convenient if you want nothing to walk to. It is also the most expensive option by far. A budget alternative is the Holiday Inn Express on Two Notch Road near the zoo. Breakfast is included and it is actually edible, which is more than I can say for most hotel breakfasts in this price range. Book early if you are visiting during a USC football game. Everything within a twenty mile radius sells out and prices triple. The biggest mistake people make is treating Columbia like Atlanta or Charlotte. It is not. Traffic is lighter, things close earlier, and the walkability is limited to specific corridors. Plan around Main Street and the capitol area. Go north for Riverbanks. Go west toward Fort Jackson if you have military history interest, though the fort itself requires advance scheduling for tours. I tried to get a tour last spring and the webpage was down for three days. Call the visitor center directly. The automated system is useless.
Get the Full Details

Season matters more than most guides admit. April and October are ideal. July will break you. The humidity here is not theoretical. I walked from my car to a restaurant in July and ended up abandoning the walk and going back to the car because I was dripping sweat before I reached the door. Winter is mild but unpredictable. I packed for snow once and got rain and seventy degree weather. Bring layers. Always. One thing nobody mentions: the library system. The Main Library on Gervais is a real building with good architecture and it is free to enter. There is a decent book selection and quiet rooms you can reserve. I used one once to plan my routes because my phone battery died and I had no charger. They have outlets near the reading tables. It felt weird using a public space just to charge a phone but nobody cared. Transportation between sites is easiest by car. Ride shares work but wait times can be ten to fifteen minutes in downtown during business hours. There is a shuttle called Commuter Link but the schedule is limited and it runs mostly on weekdays. If you do not have a car, you will be significantly restricted. I tried it once and gave up after two days. The frequency is not enough for a real tourist experience.
Final note about the Columbia Riverwalk extension project. Parts of it are still under construction. The segment near the State House is complete and nice. The stretch toward the shopping areas is spotty. Check the city website before you go expecting a continuous trail because you might hit a closed section. I walked into a construction barrier once. Embarrassing. Columbia is a real city with real flaws and real nice spots. It does not need to be anything other than what it is. Don't expect Nashville or Savannah. Expect a state capital that is trying its best. That is usually enough.